Overview
Brought to you by YData
Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 8954786 |
| Missing cells | 94 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.3 GiB |
| Average record size in memory | 160.0 B |
Variable types
| DateTime | 4 |
|---|---|
| Numeric | 11 |
| Text | 4 |
| Categorical | 1 |
bill_total_billed is highly overall correlated with bill_total_net and 3 other fields | High correlation |
bill_total_net is highly overall correlated with bill_total_billed and 3 other fields | High correlation |
bill_total_tax is highly overall correlated with bill_total_billed and 3 other fields | High correlation |
payment_amount is highly overall correlated with bill_total_billed and 4 other fields | High correlation |
payment_total_tip is highly overall correlated with payment_amount | High correlation |
sales_revenue_with_tax is highly overall correlated with bill_total_billed and 3 other fields | High correlation |
order_take_out_type_label is highly imbalanced (61.9%) | Imbalance |
bill_total_billed is highly skewed (γ1 = 144.4166783) | Skewed |
bill_total_discount_item_level is highly skewed (γ1 = 149.7226489) | Skewed |
bill_total_gratuity is highly skewed (γ1 = 479.1136713) | Skewed |
bill_total_net is highly skewed (γ1 = 134.8548939) | Skewed |
bill_total_tax is highly skewed (γ1 = 261.6218339) | Skewed |
bill_total_voided is highly skewed (γ1 = 2929.1235) | Skewed |
order_duration_seconds is highly skewed (γ1 = 238.195982) | Skewed |
payment_amount is highly skewed (γ1 = 2048.525811) | Skewed |
payment_total_tip is highly skewed (γ1 = 2960.142341) | Skewed |
sales_revenue_with_tax is highly skewed (γ1 = 144.4157221) | Skewed |
bill_uuid has unique values | Unique |
bill_total_billed has 229152 (2.6%) zeros | Zeros |
bill_total_discount_item_level has 8267805 (92.3%) zeros | Zeros |
bill_total_gratuity has 8748366 (97.7%) zeros | Zeros |
bill_total_net has 229618 (2.6%) zeros | Zeros |
bill_total_tax has 1326428 (14.8%) zeros | Zeros |
bill_total_voided has 8715185 (97.3%) zeros | Zeros |
payment_amount has 230480 (2.6%) zeros | Zeros |
payment_count has 213726 (2.4%) zeros | Zeros |
payment_total_tip has 5270130 (58.9%) zeros | Zeros |
sales_revenue_with_tax has 229169 (2.6%) zeros | Zeros |
Reproduction
| Analysis started | 2025-02-12 00:06:56.533921 |
|---|---|
| Analysis finished | 2025-02-12 00:22:30.077393 |
| Duration | 15 minutes and 33.54 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
| Distinct | 5832313 |
|---|---|
| Distinct (%) | 65.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 68.3 MiB |
| Minimum | 2024-07-01 00:00:01 |
|---|---|
| Maximum | 2025-01-01 21:41:43 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
bill_total_billed
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 52348 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.748312 |
| Minimum | -5731.5 |
|---|---|
| Maximum | 74928.61 |
| Zeros | 229152 |
| Zeros (%) | 2.6% |
| Negative | 13818 |
| Negative (%) | 0.2% |
| Memory size | 68.3 MiB |
Quantile statistics
| Minimum | -5731.5 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 10.44 |
| median | 21.89 |
| Q3 | 44.65 |
| 95-th percentile | 111 |
| Maximum | 74928.61 |
| Range | 80660.11 |
| Interquartile range (IQR) | 34.21 |
Descriptive statistics
| Standard deviation | 83.3765 |
|---|---|
| Coefficient of variation (CV) | 2.2688525 |
| Kurtosis | 84263.107 |
| Mean | 36.748312 |
| Median Absolute Deviation (MAD) | 14.27 |
| Skewness | 144.41668 |
| Sum | 3.2907327 × 108 |
| Variance | 6951.6407 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 229152 | 2.6% |
| 14.75 | 36083 | 0.4% |
| 8 | 33994 | 0.4% |
| 7 | 32542 | 0.4% |
| 6 | 31031 | 0.3% |
| 11.3 | 31014 | 0.3% |
| 15.5 | 30194 | 0.3% |
| 9.04 | 28185 | 0.3% |
| 10.17 | 27950 | 0.3% |
| 3 | 27381 | 0.3% |
| Other values (52338) | 8447260 |
| Value | Count | Frequency (%) |
| -5731.5 | 2 | |
| -4712.1 | 1 | |
| -3323.28 | 1 | |
| -2625 | 1 | |
| -2433.2 | 1 | |
| -1200 | 1 | |
| -1158.49 | 1 | |
| -1000 | 1 | |
| -822.01 | 1 | |
| -773.39 | 1 |
| Value | Count | Frequency (%) |
| 74928.61 | 1 | |
| 33928.25 | 1 | |
| 25131.48 | 1 | |
| 23132.39 | 1 | |
| 22606.78 | 1 | |
| 22088.31 | 1 | |
| 21000 | 1 | |
| 20551.26 | 1 | |
| 19866 | 1 | |
| 19021.08 | 1 |
bill_total_discount_item_level
Real number (ℝ)
Skewed  Zeros 
| Distinct | 21111 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.84038025 |
| Minimum | -91.64 |
|---|---|
| Maximum | 5490.92 |
| Zeros | 8267805 |
| Zeros (%) | 92.3% |
| Negative | 557 |
| Negative (%) | < 0.1% |
| Memory size | 68.3 MiB |
Quantile statistics
| Minimum | -91.64 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2.99 |
| Maximum | 5490.92 |
| Range | 5582.56 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 9.404221 |
|---|---|
| Coefficient of variation (CV) | 11.190436 |
| Kurtosis | 52064.222 |
| Mean | 0.84038025 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 149.72265 |
| Sum | 7525425.3 |
| Variance | 88.439374 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 8267805 | |
| 2 | 25179 | 0.3% |
| 1 | 23432 | 0.3% |
| 3 | 18672 | 0.2% |
| 5 | 17377 | 0.2% |
| 4 | 16656 | 0.2% |
| 6 | 13106 | 0.1% |
| 10 | 11484 | 0.1% |
| 8 | 9767 | 0.1% |
| 1.5 | 9302 | 0.1% |
| Other values (21101) | 542006 | 6.1% |
| Value | Count | Frequency (%) |
| -91.64 | 1 | |
| -74.3 | 1 | |
| -66.25 | 1 | |
| -62.84 | 1 | |
| -59.06 | 2 | |
| -58.62 | 2 | |
| -55 | 1 | |
| -53.6 | 1 | |
| -53.26 | 1 | |
| -50.27 | 1 |
| Value | Count | Frequency (%) |
| 5490.92 | 1 | |
| 4763.45 | 1 | |
| 4227.21 | 1 | |
| 4182 | 1 | |
| 4152 | 1 | |
| 3624.71 | 1 | |
| 3242.04 | 1 | |
| 3115.35 | 1 | |
| 3050 | 1 | |
| 2973.65 | 1 |
bill_total_gratuity
Real number (ℝ)
Skewed  Zeros 
| Distinct | 8527 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.24089563 |
| Minimum | -60 |
|---|---|
| Maximum | 11935.53 |
| Zeros | 8748366 |
| Zeros (%) | 97.7% |
| Negative | 41 |
| Negative (%) | < 0.1% |
| Memory size | 68.3 MiB |
Quantile statistics
| Minimum | -60 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 11935.53 |
| Range | 11995.53 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 8.409234 |
|---|---|
| Coefficient of variation (CV) | 34.908205 |
| Kurtosis | 517986.54 |
| Mean | 0.24089563 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 479.11367 |
| Sum | 2157168.8 |
| Variance | 70.715217 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 8748366 | |
| 0.32 | 5527 | 0.1% |
| 0.15 | 4679 | 0.1% |
| 0.64 | 2297 | < 0.1% |
| 0.24 | 1816 | < 0.1% |
| 3.6 | 1591 | < 0.1% |
| 0.45 | 1336 | < 0.1% |
| 0.12 | 1300 | < 0.1% |
| 0.3 | 1298 | < 0.1% |
| 0.48 | 1166 | < 0.1% |
| Other values (8517) | 185410 | 2.1% |
| Value | Count | Frequency (%) |
| -60 | 1 | |
| -37.8 | 1 | |
| -19.08 | 1 | |
| -18.4 | 1 | |
| -12 | 1 | |
| -11.79 | 1 | |
| -11.76 | 1 | |
| -9.58 | 1 | |
| -3.87 | 1 | |
| -3.2 | 1 |
| Value | Count | Frequency (%) |
| 11935.53 | 1 | |
| 6005 | 1 | |
| 4029.21 | 1 | |
| 4003.25 | 1 | |
| 4001.2 | 1 | |
| 3402.7 | 1 | |
| 3245 | 1 | |
| 2916.32 | 1 | |
| 2504.6 | 1 | |
| 2492.6 | 1 |
bill_total_net
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 39096 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33.898938 |
| Minimum | -5072.12 |
|---|---|
| Maximum | 66308.5 |
| Zeros | 229618 |
| Zeros (%) | 2.6% |
| Negative | 13499 |
| Negative (%) | 0.2% |
| Memory size | 68.3 MiB |
Quantile statistics
| Minimum | -5072.12 |
|---|---|
| 5-th percentile | 2.8 |
| Q1 | 9.63 |
| median | 20 |
| Q3 | 41 |
| 95-th percentile | 102 |
| Maximum | 66308.5 |
| Range | 71380.62 |
| Interquartile range (IQR) | 31.37 |
Descriptive statistics
| Standard deviation | 77.543558 |
|---|---|
| Coefficient of variation (CV) | 2.2874923 |
| Kurtosis | 71061.104 |
| Mean | 33.898938 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 134.85489 |
| Sum | 3.0355773 × 108 |
| Variance | 6013.0034 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 229618 | 2.6% |
| 8 | 87408 | 1.0% |
| 18 | 74780 | 0.8% |
| 10 | 72169 | 0.8% |
| 16 | 69570 | 0.8% |
| 15 | 68653 | 0.8% |
| 5 | 67514 | 0.8% |
| 12 | 64947 | 0.7% |
| 6 | 63182 | 0.7% |
| 7 | 61035 | 0.7% |
| Other values (39086) | 8095910 |
| Value | Count | Frequency (%) |
| -5072.12 | 2 | |
| -4170 | 1 | |
| -3323.28 | 1 | |
| -2625 | 1 | |
| -2342.09 | 1 | |
| -1200 | 1 | |
| -1158.49 | 1 | |
| -1000 | 1 | |
| -755 | 1 | |
| -695 | 1 |
| Value | Count | Frequency (%) |
| 66308.5 | 1 | |
| 30025 | 1 | |
| 22384.5 | 1 | |
| 22240.25 | 1 | |
| 20253.15 | 1 | |
| 20050 | 1 | |
| 20006 | 1 | |
| 19866 | 1 | |
| 18985 | 1 | |
| 17256 | 1 |
bill_total_tax
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 11021 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.8493749 |
| Minimum | -659.38 |
|---|---|
| Maximum | 8620.11 |
| Zeros | 1326428 |
| Zeros (%) | 14.8% |
| Negative | 10194 |
| Negative (%) | 0.1% |
| Memory size | 68.3 MiB |
Quantile statistics
| Minimum | -659.38 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.46 |
| median | 1.44 |
| Q3 | 3.45 |
| 95-th percentile | 9.85 |
| Maximum | 8620.11 |
| Range | 9279.49 |
| Interquartile range (IQR) | 2.99 |
Descriptive statistics
| Standard deviation | 7.1533854 |
|---|---|
| Coefficient of variation (CV) | 2.5105104 |
| Kurtosis | 254554.13 |
| Mean | 2.8493749 |
| Median Absolute Deviation (MAD) | 1.24 |
| Skewness | 261.62183 |
| Sum | 25515542 |
| Variance | 51.170922 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1326428 | 14.8% |
| 1.3 | 53326 | 0.6% |
| 1.04 | 52435 | 0.6% |
| 0.65 | 48969 | 0.5% |
| 0.9 | 48135 | 0.5% |
| 0.2 | 44161 | 0.5% |
| 2.08 | 44076 | 0.5% |
| 0.52 | 43785 | 0.5% |
| 1.17 | 43043 | 0.5% |
| 0.91 | 42729 | 0.5% |
| Other values (11011) | 7207699 |
| Value | Count | Frequency (%) |
| -659.38 | 2 | |
| -542.1 | 1 | |
| -91.11 | 1 | |
| -88.97 | 1 | |
| -73.85 | 1 | |
| -73.42 | 1 | |
| -72.8 | 1 | |
| -68.9 | 1 | |
| -67.01 | 1 | |
| -60.09 | 1 |
| Value | Count | Frequency (%) |
| 8620.11 | 1 | |
| 3903.25 | 1 | |
| 2891.23 | 1 | |
| 2600.78 | 1 | |
| 2038.31 | 1 | |
| 1765.08 | 1 | |
| 1566.26 | 1 | |
| 1505.53 | 1 | |
| 1334.81 | 1 | |
| 1300 | 1 |
bill_total_voided
Real number (ℝ)
Skewed  Zeros 
| Distinct | 10798 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.93750928 |
| Minimum | -4501.5 |
|---|---|
| Maximum | 1000000 |
| Zeros | 8715185 |
| Zeros (%) | 97.3% |
| Negative | 624 |
| Negative (%) | < 0.1% |
| Memory size | 68.3 MiB |
Quantile statistics
| Minimum | -4501.5 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 1000000 |
| Range | 1004501.5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 336.59661 |
|---|---|
| Coefficient of variation (CV) | 359.03283 |
| Kurtosis | 8699773.9 |
| Mean | 0.93750928 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2929.1235 |
| Sum | 8395195 |
| Variance | 113297.28 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 8715185 | |
| 8 | 5293 | 0.1% |
| 10 | 4570 | 0.1% |
| 9 | 4543 | 0.1% |
| 16 | 4454 | < 0.1% |
| 12 | 4278 | < 0.1% |
| 6 | 4047 | < 0.1% |
| 5 | 3942 | < 0.1% |
| 15 | 3707 | < 0.1% |
| 7 | 3702 | < 0.1% |
| Other values (10788) | 201065 | 2.2% |
| Value | Count | Frequency (%) |
| -4501.5 | 1 | |
| -1697 | 1 | |
| -1665.9 | 1 | |
| -1215.15 | 1 | |
| -1173.15 | 1 | |
| -784.81 | 1 | |
| -630.49 | 1 | |
| -538.55 | 1 | |
| -500 | 1 | |
| -400 | 1 |
| Value | Count | Frequency (%) |
| 1000000 | 1 | |
| 43178.4 | 1 | |
| 37405.34 | 1 | |
| 26407.46 | 1 | |
| 23172.36 | 1 | |
| 21370.88 | 1 | |
| 21274.49 | 1 | |
| 20835 | 1 | |
| 20805.02 | 1 | |
| 20071.6 | 1 |
bill_uuid
Text
Unique 
| Distinct | 8954786 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 68.3 MiB |
Length
| Max length | 49 |
|---|---|
| Median length | 49 |
| Mean length | 48.990803 |
| Min length | 36 |
Unique
| Unique | 8954786 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 240701091701~4D63608F-523C-4EFF-9A4F-78D6C44B5159 |
|---|---|
| 2nd row | 240701133659~3A0BEDE2-E9E5-484D-B909-780E485F0D69 |
| 3rd row | 240701111931~670EEB85-E939-4924-B92F-C95076B7E930 |
| 4th row | 240701150558~3D6F473E-D5EF-4BB8-AFAB-30DB2A0764C0 |
| 5th row | 240701124059~0521794C-51FC-4C30-A368-995CE4DE105F |
| Value | Count | Frequency (%) |
| 240701111931~670eeb85-e939-4924-b92f-c95076b7e930 | 1 | < 0.1% |
| 241231185507~62c6632e-2957-4f0d-8aff-cf89ca378fb4 | 1 | < 0.1% |
| 241226123511~35605033-f24b-46ed-96cd-5ee5ad0af892 | 1 | < 0.1% |
| 241226123530~8fe0f8fe-8881-4c1a-9e02-b62ee88c17d5 | 1 | < 0.1% |
| 241226135739~19c42fec-33be-4a4c-b1ab-add25a7721c0 | 1 | < 0.1% |
| 241226155336~589994ce-d6cf-46d3-9470-b4fcee070e8f | 1 | < 0.1% |
| 241226214300~babd37be-35a6-4e9e-850a-467bd2689dca | 1 | < 0.1% |
| 241227163610~521ce078-d840-46e8-a8a3-8a8e983952bb | 1 | < 0.1% |
| 241227174057~0a0b75d8-71b8-4625-80d8-91924ba9e18e | 1 | < 0.1% |
| 241227175419~fdca9a8b-8515-47a8-b438-e95fe1b7177b | 1 | < 0.1% |
| Other values (8954776) | 8954776 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 40995320 | 9.3% |
| 1 | 38564892 | 8.8% |
| 2 | 38477651 | 8.8% |
| - | 35819144 | 8.2% |
| 0 | 33441331 | 7.6% |
| 9 | 24267620 | 5.5% |
| 8 | 24253871 | 5.5% |
| 3 | 23951068 | 5.5% |
| 5 | 22977703 | 5.2% |
| 7 | 21778270 | 5.0% |
| Other values (14) | 134175289 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 438702159 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 40995320 | 9.3% |
| 1 | 38564892 | 8.8% |
| 2 | 38477651 | 8.8% |
| - | 35819144 | 8.2% |
| 0 | 33441331 | 7.6% |
| 9 | 24267620 | 5.5% |
| 8 | 24253871 | 5.5% |
| 3 | 23951068 | 5.5% |
| 5 | 22977703 | 5.2% |
| 7 | 21778270 | 5.0% |
| Other values (14) | 134175289 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 438702159 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 40995320 | 9.3% |
| 1 | 38564892 | 8.8% |
| 2 | 38477651 | 8.8% |
| - | 35819144 | 8.2% |
| 0 | 33441331 | 7.6% |
| 9 | 24267620 | 5.5% |
| 8 | 24253871 | 5.5% |
| 3 | 23951068 | 5.5% |
| 5 | 22977703 | 5.2% |
| 7 | 21778270 | 5.0% |
| Other values (14) | 134175289 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 438702159 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 40995320 | 9.3% |
| 1 | 38564892 | 8.8% |
| 2 | 38477651 | 8.8% |
| - | 35819144 | 8.2% |
| 0 | 33441331 | 7.6% |
| 9 | 24267620 | 5.5% |
| 8 | 24253871 | 5.5% |
| 3 | 23951068 | 5.5% |
| 5 | 22977703 | 5.2% |
| 7 | 21778270 | 5.0% |
| Other values (14) | 134175289 |
business_date
Date
| Distinct | 184 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 68.3 MiB |
| Minimum | 2024-07-01 00:00:00 |
|---|---|
| Maximum | 2024-12-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
order_duration_seconds
Real number (ℝ)
Skewed 
| Distinct | 118347 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8790.9683 |
| Minimum | -44 |
|---|---|
| Maximum | 2.8941241 × 108 |
| Zeros | 122 |
| Zeros (%) | < 0.1% |
| Negative | 2 |
| Negative (%) | < 0.1% |
| Memory size | 68.3 MiB |
Quantile statistics
| Minimum | -44 |
|---|---|
| 5-th percentile | 33 |
| Q1 | 110 |
| median | 1159 |
| Q3 | 3377 |
| 95-th percentile | 9741 |
| Maximum | 2.8941241 × 108 |
| Range | 2.8941246 × 108 |
| Interquartile range (IQR) | 3267 |
Descriptive statistics
| Standard deviation | 398439.78 |
|---|---|
| Coefficient of variation (CV) | 45.323766 |
| Kurtosis | 89740.817 |
| Mean | 8790.9683 |
| Median Absolute Deviation (MAD) | 1106 |
| Skewness | 238.19598 |
| Sum | 7.872124 × 1010 |
| Variance | 1.5875426 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 42 | 32247 | 0.4% |
| 43 | 31866 | 0.4% |
| 40 | 31857 | 0.4% |
| 45 | 31685 | 0.4% |
| 46 | 31684 | 0.4% |
| 44 | 31677 | 0.4% |
| 41 | 31666 | 0.4% |
| 39 | 31576 | 0.4% |
| 38 | 31420 | 0.4% |
| 47 | 31330 | 0.3% |
| Other values (118337) | 8637778 |
| Value | Count | Frequency (%) |
| -44 | 1 | < 0.1% |
| -19 | 1 | < 0.1% |
| 0 | 122 | < 0.1% |
| 1 | 2160 | < 0.1% |
| 2 | 5564 | |
| 3 | 4459 | |
| 4 | 6277 | |
| 5 | 6740 | |
| 6 | 6043 | |
| 7 | 5715 |
| Value | Count | Frequency (%) |
| 289412413 | 1 | |
| 196826278 | 1 | |
| 190832960 | 1 | |
| 179540675 | 1 | |
| 163422375 | 1 | |
| 162689496 | 1 | |
| 154425999 | 1 | |
| 151728800 | 1 | |
| 150226620 | 1 | |
| 142630398 | 1 |
| Distinct | 5441306 |
|---|---|
| Distinct (%) | 60.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 68.3 MiB |
| Minimum | 2015-10-10 19:13:37 |
|---|---|
| Maximum | 2025-01-01 18:57:30 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
| Distinct | 5803496 |
|---|---|
| Distinct (%) | 64.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 68.3 MiB |
| Minimum | 2024-07-01 00:00:01 |
|---|---|
| Maximum | 2025-01-01 21:41:43 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
order_take_out_type_label
Categorical
Imbalance 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 68.3 MiB |
| dinein | |
|---|---|
| takeout | |
| onlineorder | 270192 |
| bartab | 247617 |
| delivery | 17849 |
Length
| Max length | 11 |
|---|---|
| Median length | 6 |
| Mean length | 6.2638418 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | dinein |
|---|---|
| 2nd row | dinein |
| 3rd row | dinein |
| 4th row | dinein |
| 5th row | dinein |
Common Values
| Value | Count | Frequency (%) |
| dinein | 7443139 | |
| takeout | 975989 | 10.9% |
| onlineorder | 270192 | 3.0% |
| bartab | 247617 | 2.8% |
| delivery | 17849 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| dinein | 7443139 | |
| takeout | 975989 | 10.9% |
| onlineorder | 270192 | 3.0% |
| bartab | 247617 | 2.8% |
| delivery | 17849 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 15426662 | |
| i | 15174319 | |
| e | 8995210 | |
| d | 7731180 | |
| t | 2199595 | 3.9% |
| o | 1516373 | 2.7% |
| a | 1471223 | 2.6% |
| k | 975989 | 1.7% |
| u | 975989 | 1.7% |
| r | 805850 | 1.4% |
| Other values (4) | 818973 | 1.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 56091363 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 15426662 | |
| i | 15174319 | |
| e | 8995210 | |
| d | 7731180 | |
| t | 2199595 | 3.9% |
| o | 1516373 | 2.7% |
| a | 1471223 | 2.6% |
| k | 975989 | 1.7% |
| u | 975989 | 1.7% |
| r | 805850 | 1.4% |
| Other values (4) | 818973 | 1.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 56091363 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 15426662 | |
| i | 15174319 | |
| e | 8995210 | |
| d | 7731180 | |
| t | 2199595 | 3.9% |
| o | 1516373 | 2.7% |
| a | 1471223 | 2.6% |
| k | 975989 | 1.7% |
| u | 975989 | 1.7% |
| r | 805850 | 1.4% |
| Other values (4) | 818973 | 1.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 56091363 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 15426662 | |
| i | 15174319 | |
| e | 8995210 | |
| d | 7731180 | |
| t | 2199595 | 3.9% |
| o | 1516373 | 2.7% |
| a | 1471223 | 2.6% |
| k | 975989 | 1.7% |
| u | 975989 | 1.7% |
| r | 805850 | 1.4% |
| Other values (4) | 818973 | 1.5% |
order_uuid
Text
| Distinct | 8221819 |
|---|---|
| Distinct (%) | 91.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 68.3 MiB |
Length
| Max length | 49 |
|---|---|
| Median length | 49 |
| Mean length | 48.990803 |
| Min length | 36 |
Unique
| Unique | 7804409 ? |
|---|---|
| Unique (%) | 87.2% |
Sample
| 1st row | 240701091615~EF1C6E91-B6C4-4DF1-8A92-1B024197FEC3 |
|---|---|
| 2nd row | 240701133212~A4C33BFA-A54F-4627-B0C2-7428427FB5DE |
| 3rd row | 240701111717~6074B0AB-2432-484D-BC3F-55CC5D731818 |
| 4th row | 240701150511~EAA68F41-20ED-4FC7-B902-B0B3878AEC82 |
| 5th row | 240701123917~27764E1C-7E7F-4293-ABC7-5921310A654A |
| Value | Count | Frequency (%) |
| 241019211330~7bbb205b-b2c5-4a41-be48-3adbbb373eb1 | 92 | < 0.1% |
| 240914174325~01482558-0947-4341-8662-cf4eb18cc045 | 52 | < 0.1% |
| 240913225853~632e2003-bd52-4c2d-a42d-cbe90c35535a | 43 | < 0.1% |
| 241018211013~83c159f1-9998-42ae-b8e2-06154a4a495f | 39 | < 0.1% |
| 240726211619~ce2ffa2c-3bb0-49f9-a695-f3bb0d074c73 | 38 | < 0.1% |
| 241231213143~f495c51e-a537-4a1b-8e16-da97a132d190 | 36 | < 0.1% |
| 241012223955~38741a41-132a-4818-a003-c9dc425e4ed0 | 33 | < 0.1% |
| 241012194904~25c7b69f-c134-421a-ae23-927c922fa034 | 32 | < 0.1% |
| 241108234708~11accc10-5fbc-4559-84f0-73e7a8340afa | 31 | < 0.1% |
| 240920223808~092fe466-3c2a-46ef-8898-684dce87cd8b | 30 | < 0.1% |
| Other values (8221809) | 8954360 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 40907741 | 9.3% |
| 1 | 39112820 | 8.9% |
| 2 | 37861492 | 8.6% |
| - | 35819144 | 8.2% |
| 0 | 33250178 | 7.6% |
| 8 | 24439114 | 5.6% |
| 9 | 24274206 | 5.5% |
| 3 | 23813475 | 5.4% |
| 5 | 22916348 | 5.2% |
| 7 | 22009395 | 5.0% |
| Other values (14) | 134298246 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 438702159 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 40907741 | 9.3% |
| 1 | 39112820 | 8.9% |
| 2 | 37861492 | 8.6% |
| - | 35819144 | 8.2% |
| 0 | 33250178 | 7.6% |
| 8 | 24439114 | 5.6% |
| 9 | 24274206 | 5.5% |
| 3 | 23813475 | 5.4% |
| 5 | 22916348 | 5.2% |
| 7 | 22009395 | 5.0% |
| Other values (14) | 134298246 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 438702159 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 40907741 | 9.3% |
| 1 | 39112820 | 8.9% |
| 2 | 37861492 | 8.6% |
| - | 35819144 | 8.2% |
| 0 | 33250178 | 7.6% |
| 8 | 24439114 | 5.6% |
| 9 | 24274206 | 5.5% |
| 3 | 23813475 | 5.4% |
| 5 | 22916348 | 5.2% |
| 7 | 22009395 | 5.0% |
| Other values (14) | 134298246 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 438702159 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 40907741 | 9.3% |
| 1 | 39112820 | 8.9% |
| 2 | 37861492 | 8.6% |
| - | 35819144 | 8.2% |
| 0 | 33250178 | 7.6% |
| 8 | 24439114 | 5.6% |
| 9 | 24274206 | 5.5% |
| 3 | 23813475 | 5.4% |
| 5 | 22916348 | 5.2% |
| 7 | 22009395 | 5.0% |
| Other values (14) | 134298246 |
payment_amount
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 60807 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.638782 |
| Minimum | -5731.5 |
|---|---|
| Maximum | 522752.27 |
| Zeros | 230480 |
| Zeros (%) | 2.6% |
| Negative | 13469 |
| Negative (%) | 0.2% |
| Memory size | 68.3 MiB |
Quantile statistics
| Minimum | -5731.5 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 10.97 |
| median | 23.47 |
| Q3 | 48.87 |
| 95-th percentile | 125.05 |
| Maximum | 522752.27 |
| Range | 528483.77 |
| Interquartile range (IQR) | 37.9 |
Descriptive statistics
| Standard deviation | 198.72923 |
|---|---|
| Coefficient of variation (CV) | 4.8901375 |
| Kurtosis | 5349711.7 |
| Mean | 40.638782 |
| Median Absolute Deviation (MAD) | 15.56 |
| Skewness | 2048.5258 |
| Sum | 3.6391159 × 108 |
| Variance | 39493.307 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 230480 | 2.6% |
| 14.75 | 33121 | 0.4% |
| 7 | 28667 | 0.3% |
| 6 | 27963 | 0.3% |
| 8 | 27770 | 0.3% |
| 15.5 | 26348 | 0.3% |
| 3 | 25961 | 0.3% |
| 5 | 23937 | 0.3% |
| 11.3 | 23790 | 0.3% |
| 12 | 23258 | 0.3% |
| Other values (60797) | 8483491 |
| Value | Count | Frequency (%) |
| -5731.5 | 2 | |
| -4712.1 | 1 | |
| -3323.28 | 1 | |
| -2625 | 1 | |
| -2433.2 | 1 | |
| -1200 | 1 | |
| -1158.49 | 1 | |
| -1000 | 1 | |
| -822.01 | 1 | |
| -773.39 | 1 |
| Value | Count | Frequency (%) |
| 522752.27 | 1 | |
| 86864.14 | 1 | |
| 39933.25 | 1 | |
| 29134.73 | 1 | |
| 27161.6 | 1 | |
| 26607.98 | 1 | |
| 25333.31 | 1 | |
| 25050.63 | 1 | |
| 24348.26 | 1 | |
| 23786.14 | 1 |
payment_count
Real number (ℝ)
Zeros 
| Distinct | 25 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.98444251 |
| Minimum | 0 |
|---|---|
| Maximum | 41 |
| Zeros | 213726 |
| Zeros (%) | 2.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 68.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 41 |
| Range | 41 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1926432 |
|---|---|
| Coefficient of variation (CV) | 0.19568761 |
| Kurtosis | 536.27749 |
| Mean | 0.98444251 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.3116816 |
| Sum | 8815472 |
| Variance | 0.037111402 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 8678322 | |
| 0 | 213726 | 2.4% |
| 2 | 55558 | 0.6% |
| 3 | 4949 | 0.1% |
| 4 | 1226 | < 0.1% |
| 5 | 538 | < 0.1% |
| 6 | 210 | < 0.1% |
| 7 | 111 | < 0.1% |
| 8 | 52 | < 0.1% |
| 9 | 29 | < 0.1% |
| Other values (15) | 65 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 213726 | 2.4% |
| 1 | 8678322 | |
| 2 | 55558 | 0.6% |
| 3 | 4949 | 0.1% |
| 4 | 1226 | < 0.1% |
| 5 | 538 | < 0.1% |
| 6 | 210 | < 0.1% |
| 7 | 111 | < 0.1% |
| 8 | 52 | < 0.1% |
| 9 | 29 | < 0.1% |
| Value | Count | Frequency (%) |
| 41 | 1 | < 0.1% |
| 29 | 1 | < 0.1% |
| 27 | 1 | < 0.1% |
| 23 | 1 | < 0.1% |
| 22 | 2 | |
| 20 | 1 | < 0.1% |
| 19 | 1 | < 0.1% |
| 18 | 2 | |
| 17 | 2 | |
| 16 | 3 |
payment_total_tip
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 12894 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.6542116 |
| Minimum | -253.14 |
|---|---|
| Maximum | 522715.64 |
| Zeros | 5270130 |
| Zeros (%) | 58.9% |
| Negative | 104 |
| Negative (%) | < 0.1% |
| Memory size | 68.3 MiB |
Quantile statistics
| Minimum | -253.14 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 4.07 |
| 95-th percentile | 16.81 |
| Maximum | 522715.64 |
| Range | 522968.78 |
| Interquartile range (IQR) | 4.07 |
Descriptive statistics
| Standard deviation | 175.31856 |
|---|---|
| Coefficient of variation (CV) | 47.977125 |
| Kurtosis | 8824410.7 |
| Mean | 3.6542116 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2960.1423 |
| Sum | 32722683 |
| Variance | 30736.599 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5270130 | |
| 5 | 176041 | 2.0% |
| 2 | 148820 | 1.7% |
| 10 | 139597 | 1.6% |
| 1 | 128279 | 1.4% |
| 3 | 101440 | 1.1% |
| 4 | 70049 | 0.8% |
| 20 | 58749 | 0.7% |
| 6 | 57866 | 0.6% |
| 8 | 49234 | 0.5% |
| Other values (12884) | 2754581 |
| Value | Count | Frequency (%) |
| -253.14 | 1 | |
| -207.36 | 1 | |
| -198.42 | 1 | |
| -189.5 | 1 | |
| -179.9 | 1 | |
| -129.8 | 1 | |
| -101.7 | 1 | |
| -99 | 1 | |
| -83.88 | 1 | |
| -79.7 | 1 |
| Value | Count | Frequency (%) |
| 522715.64 | 1 | |
| 23762.38 | 1 | |
| 17668.02 | 1 | |
| 11097.36 | 1 | |
| 5180.16 | 1 | |
| 4350.09 | 1 | |
| 4050.63 | 1 | |
| 3797 | 1 | |
| 3080 | 1 | |
| 2940 | 1 |
sales_revenue_with_tax
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 52346 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.749018 |
| Minimum | -5731.5 |
|---|---|
| Maximum | 74928.61 |
| Zeros | 229169 |
| Zeros (%) | 2.6% |
| Negative | 13817 |
| Negative (%) | 0.2% |
| Memory size | 68.3 MiB |
Quantile statistics
| Minimum | -5731.5 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 10.44 |
| median | 21.89 |
| Q3 | 44.65 |
| 95-th percentile | 111 |
| Maximum | 74928.61 |
| Range | 80660.11 |
| Interquartile range (IQR) | 34.21 |
Descriptive statistics
| Standard deviation | 83.37668 |
|---|---|
| Coefficient of variation (CV) | 2.2688138 |
| Kurtosis | 84262.373 |
| Mean | 36.749018 |
| Median Absolute Deviation (MAD) | 14.27 |
| Skewness | 144.41572 |
| Sum | 3.2907959 × 108 |
| Variance | 6951.6707 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 229169 | 2.6% |
| 14.75 | 36083 | 0.4% |
| 8 | 33994 | 0.4% |
| 7 | 32542 | 0.4% |
| 6 | 31031 | 0.3% |
| 11.3 | 31014 | 0.3% |
| 15.5 | 30194 | 0.3% |
| 9.04 | 28185 | 0.3% |
| 10.17 | 27950 | 0.3% |
| 3 | 27381 | 0.3% |
| Other values (52336) | 8447243 |
| Value | Count | Frequency (%) |
| -5731.5 | 2 | |
| -4712.1 | 1 | |
| -3323.28 | 1 | |
| -2625 | 1 | |
| -2433.2 | 1 | |
| -1200 | 1 | |
| -1158.49 | 1 | |
| -1000 | 1 | |
| -822.01 | 1 | |
| -773.39 | 1 |
| Value | Count | Frequency (%) |
| 74928.61 | 1 | |
| 33928.25 | 1 | |
| 25131.48 | 1 | |
| 23132.39 | 1 | |
| 22606.78 | 1 | |
| 22088.31 | 1 | |
| 21000 | 1 | |
| 20551.26 | 1 | |
| 19866 | 1 | |
| 19021.08 | 1 |
venue_xref_id
Text
| Distinct | 601 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 68.3 MiB |
Length
| Max length | 64 |
|---|---|
| Median length | 64 |
| Mean length | 64 |
| Min length | 64 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df |
|---|---|
| 2nd row | 39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df |
| 3rd row | 39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df |
| 4th row | 39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df |
| 5th row | 39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df |
| Value | Count | Frequency (%) |
| 5e8a21ead84851c212c2cae58849de4d37bc0babfcab05ceff51350412eb3e94 | 86044 | 1.0% |
| 6c4ddbba39d1529689be33c4769223b1194ba2dcb9e20f266d18face3279d00a | 80194 | 0.9% |
| a7de7d703442f619ab305b7752fd215d85b28bad1dba9f01715d38fec9ce0efb | 78213 | 0.9% |
| 1fba23fbdd499646399a75417304d971f5fdea72bce5ba4b0d9e6086ac093892 | 75070 | 0.8% |
| 68e559beb80a2ae3cbdbf07043ebf35fbbccd85494216a2f32b31da76ece5ac0 | 74152 | 0.8% |
| 5dc459c71f4739c3dbd5872b4d442295864cf5715f704b19e02e1a581453561a | 72908 | 0.8% |
| 92128c7fc22f3f685e9914450a0bd855e258aafff9351663260b080a4a7c5188 | 68561 | 0.8% |
| 6afc5202235f3b742e6482c94536ab8462f6022054eccb0c6d5630c211c0a7fe | 66480 | 0.7% |
| 5ece4507d7aec26fdcca66082fcc77457f79cea602c1a82122c7ea496d37c493 | 65448 | 0.7% |
| 3c5a0e6460177d012e070306ba429335066823de1e25aa1ffbd3df7966cacd81 | 64779 | 0.7% |
| Other values (591) | 8222937 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 38593238 | 6.7% |
| c | 37575268 | 6.6% |
| e | 37459095 | 6.5% |
| 0 | 36401005 | 6.4% |
| f | 36188145 | 6.3% |
| a | 35852502 | 6.3% |
| d | 35836090 | 6.3% |
| 3 | 35746675 | 6.2% |
| b | 35664639 | 6.2% |
| 6 | 35388616 | 6.2% |
| Other values (6) | 208401031 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 573106304 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 38593238 | 6.7% |
| c | 37575268 | 6.6% |
| e | 37459095 | 6.5% |
| 0 | 36401005 | 6.4% |
| f | 36188145 | 6.3% |
| a | 35852502 | 6.3% |
| d | 35836090 | 6.3% |
| 3 | 35746675 | 6.2% |
| b | 35664639 | 6.2% |
| 6 | 35388616 | 6.2% |
| Other values (6) | 208401031 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 573106304 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 38593238 | 6.7% |
| c | 37575268 | 6.6% |
| e | 37459095 | 6.5% |
| 0 | 36401005 | 6.4% |
| f | 36188145 | 6.3% |
| a | 35852502 | 6.3% |
| d | 35836090 | 6.3% |
| 3 | 35746675 | 6.2% |
| b | 35664639 | 6.2% |
| 6 | 35388616 | 6.2% |
| Other values (6) | 208401031 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 573106304 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 38593238 | 6.7% |
| c | 37575268 | 6.6% |
| e | 37459095 | 6.5% |
| 0 | 36401005 | 6.4% |
| f | 36188145 | 6.3% |
| a | 35852502 | 6.3% |
| d | 35836090 | 6.3% |
| 3 | 35746675 | 6.2% |
| b | 35664639 | 6.2% |
| 6 | 35388616 | 6.2% |
| Other values (6) | 208401031 |
waiter_uuid
Text
| Distinct | 9162 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 94 |
| Missing (%) | < 0.1% |
| Memory size | 68.3 MiB |
Length
| Max length | 49 |
|---|---|
| Median length | 49 |
| Mean length | 47.36324 |
| Min length | 20 |
Unique
| Unique | 341 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD |
|---|---|
| 2nd row | 161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD |
| 3rd row | 161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD |
| 4th row | 161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD |
| 5th row | 161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD |
| Value | Count | Frequency (%) |
| 190405092446~8646fe39-600c-4318-bea7-0a31d4082914 | 431432 | 4.8% |
| 220405145647~93ca8d12-f48a-44ec-bf83-2674a4dc6094 | 73563 | 0.8% |
| 200122200826~9afddbd1-59a4-4016-ad66-830100e21632 | 43295 | 0.5% |
| 220808130537~4ff8785d-4a7b-49ff-a7fe-b8551b6591d0 | 38721 | 0.4% |
| 200217111829~15f6aab8-87ad-4e90-a5ca-f6ed08fc1e4f | 37727 | 0.4% |
| 150101000000~99c97c5b-82ae-48b5-a578-cc528ee0c57c | 37421 | 0.4% |
| cc66dfde-4181-46f5-a04d-d14424650700 | 37380 | 0.4% |
| 201209123916~356b9122-4031-4a51-886f-8dcea9d8afc5 | 36170 | 0.4% |
| 230711173726~12a0de3a-7ef0-4477-bbee-4b422343fab9 | 33057 | 0.4% |
| 220528101742~8c27e6e6-4320-45ad-aea9-fdb28a8364cd | 31541 | 0.4% |
| Other values (9152) | 8154385 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 36033458 | 8.5% |
| - | 35818720 | 8.4% |
| 0 | 35781314 | 8.4% |
| 1 | 35628843 | 8.4% |
| 2 | 33658061 | 7.9% |
| 3 | 24410284 | 5.8% |
| 9 | 23365754 | 5.5% |
| 5 | 23032400 | 5.4% |
| 8 | 23003734 | 5.4% |
| 6 | 21311769 | 5.0% |
| Other values (23) | 132078893 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 424123230 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 36033458 | 8.5% |
| - | 35818720 | 8.4% |
| 0 | 35781314 | 8.4% |
| 1 | 35628843 | 8.4% |
| 2 | 33658061 | 7.9% |
| 3 | 24410284 | 5.8% |
| 9 | 23365754 | 5.5% |
| 5 | 23032400 | 5.4% |
| 8 | 23003734 | 5.4% |
| 6 | 21311769 | 5.0% |
| Other values (23) | 132078893 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 424123230 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 36033458 | 8.5% |
| - | 35818720 | 8.4% |
| 0 | 35781314 | 8.4% |
| 1 | 35628843 | 8.4% |
| 2 | 33658061 | 7.9% |
| 3 | 24410284 | 5.8% |
| 9 | 23365754 | 5.5% |
| 5 | 23032400 | 5.4% |
| 8 | 23003734 | 5.4% |
| 6 | 21311769 | 5.0% |
| Other values (23) | 132078893 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 424123230 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 36033458 | 8.5% |
| - | 35818720 | 8.4% |
| 0 | 35781314 | 8.4% |
| 1 | 35628843 | 8.4% |
| 2 | 33658061 | 7.9% |
| 3 | 24410284 | 5.8% |
| 9 | 23365754 | 5.5% |
| 5 | 23032400 | 5.4% |
| 8 | 23003734 | 5.4% |
| 6 | 21311769 | 5.0% |
| Other values (23) | 132078893 |
Interactions
Correlations
| bill_total_billed | bill_total_discount_item_level | bill_total_gratuity | bill_total_net | bill_total_tax | bill_total_voided | order_duration_seconds | order_take_out_type_label | payment_amount | payment_count | payment_total_tip | sales_revenue_with_tax | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| bill_total_billed | 1.000 | -0.076 | 0.077 | 0.999 | 0.779 | -0.058 | 0.478 | 0.004 | 0.995 | 0.259 | 0.457 | 1.000 |
| bill_total_discount_item_level | -0.076 | 1.000 | -0.003 | -0.076 | -0.061 | -0.001 | 0.107 | 0.006 | -0.073 | -0.174 | -0.017 | -0.076 |
| bill_total_gratuity | 0.077 | -0.003 | 1.000 | 0.077 | 0.078 | 0.006 | 0.082 | 0.003 | 0.090 | 0.026 | 0.023 | 0.077 |
| bill_total_net | 0.999 | -0.076 | 0.077 | 1.000 | 0.756 | -0.058 | 0.473 | 0.004 | 0.994 | 0.259 | 0.454 | 0.999 |
| bill_total_tax | 0.779 | -0.061 | 0.078 | 0.756 | 1.000 | -0.052 | 0.445 | 0.005 | 0.781 | 0.225 | 0.419 | 0.779 |
| bill_total_voided | -0.058 | -0.001 | 0.006 | -0.058 | -0.052 | 1.000 | 0.103 | 0.000 | -0.057 | -0.372 | -0.017 | -0.058 |
| order_duration_seconds | 0.478 | 0.107 | 0.082 | 0.473 | 0.445 | 0.103 | 1.000 | 0.002 | 0.492 | -0.048 | 0.351 | 0.478 |
| order_take_out_type_label | 0.004 | 0.006 | 0.003 | 0.004 | 0.005 | 0.000 | 0.002 | 1.000 | 0.001 | 0.001 | 0.000 | 0.004 |
| payment_amount | 0.995 | -0.073 | 0.090 | 0.994 | 0.781 | -0.057 | 0.492 | 0.001 | 1.000 | 0.259 | 0.521 | 0.995 |
| payment_count | 0.259 | -0.174 | 0.026 | 0.259 | 0.225 | -0.372 | -0.048 | 0.001 | 0.259 | 1.000 | 0.118 | 0.259 |
| payment_total_tip | 0.457 | -0.017 | 0.023 | 0.454 | 0.419 | -0.017 | 0.351 | 0.000 | 0.521 | 0.118 | 1.000 | 0.457 |
| sales_revenue_with_tax | 1.000 | -0.076 | 0.077 | 0.999 | 0.779 | -0.058 | 0.478 | 0.004 | 0.995 | 0.259 | 0.457 | 1.000 |